Sales Transaction Amounts History (SOP30300)

azurecurve Products Microsoft Dynamics GP (0)SalesSales Transaction Amounts History (SOP30300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP30300

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction Amounts History
Physical Name: SOP30300
Technical Name: SOP_LINE_HIST

Group Display Name: Sales History
Group Technical Name: Sales History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
2	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
3	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
4	CMPNTSEQ	Component Sequence	Long Integer	LI_Sequence_Number	10
5	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Sales Transaction Amounts History'].ITEMNMBR AS 'Sales Transaction Amounts History-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN IV00101 AS ['Item Master'] ON ['Sales Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	ITEMDESC	Item Description	String	STR100	100
7	NONINVEN	Non IV	Integer	INT1	1
	Used to indicate whether an item is an inventory item or non-inventory item. Click to show/hide PO Line Statuses 0 Inventory item 1 Non-inventory item
8	DROPSHIP	Drop Ship	Integer	INT2	2
9	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.
10	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Sales Transaction Amounts History'].LOCNCODE AS 'Sales Transaction Amounts History-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Sales Transaction Amounts History'].LOCNCODE = ['Site Setup'].LOCNCODE
11	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
12	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
13	UNITPRCE	Unit Price	Currency	DLR17_RBS0_STR$	17
14	ORUNTPRC	Originating Unit Price	Currency	DLR17_RBS0_STR$	17
15	XTNDPRCE	Extended Price	Currency	DLR17_RBS0_STR$	17
16	OXTNDPRC	Originating Extended Price	Currency	DLR17_RBS0_STR$	17
17	REMPRICE	Remaining Price	Currency	DLR17_RBS0_UTR$	17
18	OREPRICE	Originating Remaining Price	Currency	DLR17_RBS0_UTR$	17
19	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
20	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
21	MRKDNAMT	Markdown Amount	Currency	DLR17_RBS0_UTR$	17
22	ORMRKDAM	Originating Markdown Amount	Currency	DLR17_RBS0_UTR$	17
23	MRKDNPCT	Markdown Percent	Integer	INT5_%2	5
24	MRKDNTYP	Markdown Type	Integer	GB	0
25	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].INVINDX AS 'Sales Transaction Amounts History-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].INVINDX = ['Account Index Master'].ACTINDX
26	CSLSINDX	Cost Of Sales Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].CSLSINDX AS 'Sales Transaction Amounts History-Cost Of Sales Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].CSLSINDX = ['Account Index Master'].ACTINDX
27	SLSINDX	Sales Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].SLSINDX AS 'Sales Transaction Amounts History-Sales Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].SLSINDX = ['Account Index Master'].ACTINDX
28	MKDNINDX	Markdown Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].MKDNINDX AS 'Sales Transaction Amounts History-Markdown Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].MKDNINDX = ['Account Index Master'].ACTINDX
29	RTNSINDX	Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].RTNSINDX AS 'Sales Transaction Amounts History-Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].RTNSINDX = ['Account Index Master'].ACTINDX
30	INUSINDX	In Use Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].INUSINDX AS 'Sales Transaction Amounts History-In Use Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].INUSINDX = ['Account Index Master'].ACTINDX
31	INSRINDX	In Service Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].INSRINDX AS 'Sales Transaction Amounts History-In Service Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].INSRINDX = ['Account Index Master'].ACTINDX
32	DMGDINDX	Damaged Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales Transaction Amounts History'].DMGDINDX AS 'Sales Transaction Amounts History-Damaged Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales Transaction Amounts History'].DMGDINDX = ['Account Index Master'].ACTINDX
33	ITMTSHID	Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Sales Transaction Amounts History'].ITMTSHID AS 'Sales Transaction Amounts History-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Sales Transaction Amounts History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34	IVITMTXB	IV Item Taxable	Integer	DDL_Tax_Options	0
35	BKTSLSAM	Backout Sales Amount	Currency	DLR19_RBS0_UTR$	19
36	ORBKTSLS	Originating Backout Sales Amount	Currency	DLR19_RBS0_UTR$	19
37	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
38	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
39	TXBTXAMT	Taxable Tax Amount	Currency	DLR19_RBSO_UTR$	19
40	OTAXTAMT	Originating Taxable Tax Amount	Currency	DLR17_RBS0_UTR$	17
41	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
42	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
43	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
44	DISCSALE	Discount Available Sales	Currency	DLR17_RBS0_UTR$	17
45	ORDAVSLS	Originating Discount Available Sales	Currency	DLR17_RBS0_UTR$	17
46	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
47	ATYALLOC	QTY Allocated	Currency	DLR17_QTY_RBS0_UTR	17
48	QTYINSVC	QTY In Service	Currency	DLR17_QTY_RBS0_UTR	17
49	QTYINUSE	QTY In Use	Currency	DLR17_QTY_RBS0_UTR	17
50	QTYDMGED	QTY Damaged	Currency	DLR17_QTY_RBS0_UTR	17
51	QTYRTRND	QTY Returned	Currency	DLR17_QTY_RBS0_UTR	17
52	QTYONHND	QTY On Hand	Currency	DLR17_QTY_RBS0_STR	17
53	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
54	QTYCANOT	QTY Canceled Other	Currency	DLR17_QTY_RBS0_UTR	17
55	QTYORDER	QTY Ordered	Currency	DLR17_QTY_RBS0_UTR	17
56	QTYPRBAC	QTY Prev Back Ordered	Currency	DLR17_QTY_RBS0_UTR	17
57	QTYPRBOO	QTY Prev BO On Order	Currency	DLR17_QTY_RBS0_UTR	17
58	QTYPRINV	QTY Prev Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
59	QTYPRORD	QTY Prev Ordered	Currency	DLR17_QTY_RBS0_UTR	17
60	QTYPRVRECVD	QTY Prev Received	Currency	DLR17_QTY_RBS0_UTR	17
61	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
62	QTYREMAI	QTY Remaining	Currency	DLR17_QTY_RBS0_UTR	17
63	QTYREMBO	QTY Remaining On BO	Currency	DLR17_QTY_RBS0_UTR	17
64	QTYTBAOR	QTY To Back Order	Currency	DLR17_QTY_RBS0_UTR	17
65	QTYTOINV	QTY To Invoice	Currency	DLR17_QTY_RBS0_UTR	17
66	QTYTORDR	QTY To Order	Currency	DLR17_QTY_RBS0_UTR	17
67	QTYFULFI	QTY Fulfilled	Currency	DLR17_QTY_RBS0_UTR	17
68	QTYSLCTD	QTY Selected	Currency	DLR17_QTY_RBS0_UTR	17
69	QTYBSUOM	QTY In Base U Of M	Currency	DLR17_QTY_RBS0_STR	17
70	EXTQTYAL	Existing Qty Available	Currency	DLR17_RBS0_UTR$	17
71	EXTQTYSEL	Existing Qty Selected	Currency	DLR17_QTY_RBS0_STR	17
72	ReqShipDate	Requested Ship Date	Date	DT	8
73	FUFILDAT	Fulfillment Date	Date	DT	8
74	ACTLSHIP	Actual Ship Date	Date	DT	8
75	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Sales Transaction Amounts History'].SHIPMTHD AS 'Sales Transaction Amounts History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Sales Transaction Amounts History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
76	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['Sales Transaction Amounts History'].SALSTERR AS 'Sales Transaction Amounts History-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['Sales Transaction Amounts History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
77	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['Sales Transaction Amounts History'].SLPRSNID AS 'Sales Transaction Amounts History-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['Sales Transaction Amounts History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
78	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
79	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Sales Transaction Amounts History'].COMMNTID AS 'Sales Transaction Amounts History-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Sales Transaction Amounts History'].COMMNTID = ['Comment Master'].COMMNTID
80	BRKFLD1	Break Field 1	Integer	INT1	1
81	BRKFLD2	Break Field 2	Integer	INT1	1
82	BRKFLD3	Break Field 3	Integer	INT1	1
83	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Sales Transaction Amounts History'].CURRNIDX AS 'Sales Transaction Amounts History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Sales Transaction Amounts History'].CURRNIDX = ['Currency Setup'].CURRNIDX
84	TRXSORCE	TRX Source	String	STR13	13
85	SOPLNERR	SOP LINE Errors	Long Integer	ML_SOP_LINE_Errors	0
86	DOCNCORR	Document Number Corrected	String	Document_Number	20
87	ORGSEQNM	Original Sequence Number Corrected	Long Integer	LI_Sequence_Number	10
88	ITEMCODE	Item Code	String	STR15	15
89	PURCHSTAT	Purchasing Status	Integer	DDL_PurchasingStatus	0
90	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
91	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
92	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
93	EXCEPTIONALDEMAND	Exceptional Demand	Boolean	CB_Exceptional_Demand	0
94	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Sales Transaction Amounts History'].TAXSCHID AS 'Sales Transaction Amounts History-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Sales Transaction Amounts History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
95	TXSCHSRC	Tax Schedule Source	Integer	INT1	1
96	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
97	ShipToName	ShipToName	String	STR64_Customer_Name	64
98	CNTCPRSN	Contact Person	String	STR60	60
99	ADDRESS1	Address 1	String	STR60	60
100	ADDRESS2	Address 2	String	STR60	60
101	ADDRESS3	Address 3	String	STR60	60
102	CITY	City	String	STR35	35
103	STATE	State	String	STR30_State	29
104	ZIPCODE	Zip Code	String	STR10	10
105	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Sales Transaction Amounts History'].CCode AS 'Sales Transaction Amounts History-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM SOP30300 AS ['Sales Transaction Amounts History'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Sales Transaction Amounts History'].CCode = ['VAT Country Code MSTR'].CCode
106	COUNTRY	Country	String	STR60	60
107	PHONE1	Phone 1	String	Phone_Number	14
108	PHONE2	Phone 2	String	Phone_Number	14
109	PHONE3	Phone 3	String	Phone_Number3	14
110	FAXNUMBR	Fax Number	String	STR14_FAX	14
111	Flags	Flags	Integer	INT1	1
112	CONTNBR	Contract Number	String	STR11	11
113	CONTLNSEQNBR	Contract Line SEQ Number	Currency	Sequence_Number	19
114	CONTSTARTDTE	Contract Start Date	Date	DATE	6
115	CONTENDDTE	Contract End Date	Date	DATE_L	0
116	CONTITEMNBR	Contract Item Number	String	STR30_Item_Number	30
117	CONTSERIALNBR	Contract Serial Number	String	STR20_LBAU	20
118	ISLINEINTRA	IsLineIntrastat	Boolean	CB	0
119	Print_Phone_NumberGB	Print Phone Number GB	Integer	GB	0

azurecurve Products Microsoft Dynamics GP (0)SalesSales Transaction Amounts History (SOP30300)

Leave a Reply Cancel reply